INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES
((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'RMS'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'V RMS A', 0, 1, 0, 0, NULL, 1, 0, 1);INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V RMS A' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'VA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'RMS'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'V RMS B', 0, 1, 0, 0, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V RMS B' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'VB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'RMS'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'V RMS C', 0, 1, 0, 0, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V RMS C' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'VC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'RMS'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'I RMS A', 0, 1, 0, 0, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I RMS A' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'IA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'RMS'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'I RMS B', 0, 1, 0, 0, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I RMS B' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'IB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'RMS'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'I RMS C', 0, 1, 0, 0, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I RMS C' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'IC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'RMS'),
(SELECT ID FROM Phase WHERE Name LIKE 'NG'),
'I RMS N', 0, 1, 0, 0, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I RMS N' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'IN_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'TotalTHD'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'V THD A', 0, 1, 0, 0, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V THD A' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'THDVA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'TotalTHD'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'V THD B', 0, 1, 0, 0, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V THD B' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'THDVB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'TotalTHD'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'V THD C', 0, 1, 0, 0, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V THD C' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'THDVC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'TotalTHD'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'I THD A', 0, 1, 0, 0, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I THD A' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'THDIA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'TotalTHD'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'I THD B', 0, 1, 0, 0, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I THD B' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'THDIB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'TotalTHD'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'I THD C', 0, 1, 0, 0, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I THD C' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'THDIC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'TotalTHD'),
(SELECT ID FROM Phase WHERE Name LIKE 'NG'),
'I THD N', 0, 1, 0, 0, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I THD N' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'THDIN_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'FlkrPST'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'V Flicker Pst A', 0, 1, 0, 0, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Flicker Pst A' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'PST_10MIN_VA');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'FlkrPST'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'V Flicker Pst B', 0, 1, 0, 0, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Flicker Pst B' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'PST_10MIN_VB');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'FlkrPST'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'V Flicker Pst C', 0, 1, 0, 0, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Flicker Pst C' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'PST_10MIN_VC');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'V Harmonic A 2', 0, 1, 0, 2, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 2' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM2_VA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'V Harmonic A 3', 0, 1, 0, 3, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 3' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM3_VA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'V Harmonic A 4', 0, 1, 0, 4, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 4' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM4_VA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'V Harmonic A 5', 0, 1, 0, 5, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 5' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM5_VA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'V Harmonic A 6', 0, 1, 0, 6, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 6' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM6_VA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'V Harmonic A 7', 0, 1, 0, 7, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 7' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM7_VA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'V Harmonic A 8', 0, 1, 0, 8, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 8' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM8_VA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'V Harmonic A 9', 0, 1, 0, 9, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 9' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM9_VA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'V Harmonic A 10', 0, 1, 0, 10, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 10' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM10_VA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'V Harmonic A 11', 0, 1, 0, 11, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 11' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM11_VA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'V Harmonic A 12', 0, 1, 0, 12, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 12' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM12_VA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'V Harmonic A 13', 0, 1, 0, 13, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 13' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM13_VA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'V Harmonic A 14', 0, 1, 0, 14, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 14' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM14_VA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'V Harmonic A 15', 0, 1, 0, 15, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 15' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM15_VA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'V Harmonic A 16', 0, 1, 0, 16, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 16' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM16_VA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'V Harmonic A 17', 0, 1, 0, 17, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 17' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM17_VA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'V Harmonic A 18', 0, 1, 0, 18, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 18' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM18_VA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'V Harmonic A 19', 0, 1, 0, 19, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 19' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM19_VA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'V Harmonic A 20', 0, 1, 0, 20, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 20' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM20_VA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'V Harmonic A 21', 0, 1, 0, 21, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 21' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM21_VA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'V Harmonic A 22', 0, 1, 0, 22, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 22' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM22_VA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'V Harmonic A 23', 0, 1, 0, 23, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 23' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM23_VA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'V Harmonic A 24', 0, 1, 0, 24, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 24' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM24_VA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'V Harmonic A 25', 0, 1, 0, 25, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 25' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM25_VA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'V Harmonic A 26', 0, 1, 0, 26, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 26' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM26_VA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'V Harmonic A 27', 0, 1, 0, 27, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 27' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM27_VA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'V Harmonic A 28', 0, 1, 0, 28, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 28' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM28_VA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'V Harmonic A 29', 0, 1, 0, 29, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 29' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM29_VA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'V Harmonic A 30', 0, 1, 0, 30, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 30' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM30_VA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'V Harmonic A 31', 0, 1, 0, 31, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 31' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM31_VA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'V Harmonic A 32', 0, 1, 0, 32, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 32' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM32_VA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'V Harmonic A 33', 0, 1, 0, 33, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 33' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM33_VA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'V Harmonic B 2', 0, 1, 0, 2, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 2' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM2_VB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'V Harmonic B 3', 0, 1, 0, 3, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 3' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM3_VB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'V Harmonic B 4', 0, 1, 0, 4, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 4' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM4_VB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'V Harmonic B 5', 0, 1, 0, 5, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 5' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM5_VB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'V Harmonic B 6', 0, 1, 0, 6, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 6' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM6_VB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'V Harmonic B 7', 0, 1, 0, 7, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 7' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM7_VB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'V Harmonic B 8', 0, 1, 0, 8, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 8' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM8_VB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'V Harmonic B 9', 0, 1, 0, 9, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 9' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM9_VB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'V Harmonic B 10', 0, 1, 0, 10, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 10' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM10_VB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'V Harmonic B 11', 0, 1, 0, 11, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 11' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM11_VB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'V Harmonic B 12', 0, 1, 0, 12, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 12' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM12_VB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'V Harmonic B 13', 0, 1, 0, 13, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 13' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM13_VB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'V Harmonic B 14', 0, 1, 0, 14, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 14' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM14_VB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'V Harmonic B 15', 0, 1, 0, 15, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 15' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM15_VB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'V Harmonic B 16', 0, 1, 0, 16, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 16' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM16_VB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'V Harmonic B 17', 0, 1, 0, 17, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 17' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM17_VB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'V Harmonic B 18', 0, 1, 0, 18, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 18' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM18_VB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'V Harmonic B 19', 0, 1, 0, 19, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 19' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM19_VB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'V Harmonic B 20', 0, 1, 0, 20, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 20' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM20_VB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'V Harmonic B 21', 0, 1, 0, 21, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 21' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM21_VB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'V Harmonic B 22', 0, 1, 0, 22, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 22' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM22_VB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'V Harmonic B 23', 0, 1, 0, 23, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 23' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM23_VB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'V Harmonic B 24', 0, 1, 0, 24, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 24' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM24_VB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'V Harmonic B 25', 0, 1, 0, 25, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 25' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM25_VB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'V Harmonic B 26', 0, 1, 0, 26, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 26' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM26_VB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'V Harmonic B 27', 0, 1, 0, 27, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 27' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM27_VB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'V Harmonic B 28', 0, 1, 0, 28, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 28' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM28_VB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'V Harmonic B 29', 0, 1, 0, 29, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 29' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM29_VB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'V Harmonic B 30', 0, 1, 0, 30, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 30' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM30_VB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'V Harmonic B 31', 0, 1, 0, 31, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 31' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM31_VB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'V Harmonic B 32', 0, 1, 0, 32, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 32' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM32_VB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'V Harmonic B 33', 0, 1, 0, 33, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 33' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM33_VB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'V Harmonic C 2', 0, 1, 0, 2, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 2' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM2_VC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'V Harmonic C 3', 0, 1, 0, 3, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 3' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM3_VC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'V Harmonic C 4', 0, 1, 0, 4, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 4' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM4_VC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'V Harmonic C 5', 0, 1, 0, 5, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 5' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM5_VC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'V Harmonic C 6', 0, 1, 0, 6, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 6' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM6_VC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'V Harmonic C 7', 0, 1, 0, 7, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 7' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM7_VC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'V Harmonic C 8', 0, 1, 0, 8, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 8' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM8_VC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'V Harmonic C 9', 0, 1, 0, 9, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 9' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM9_VC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'V Harmonic C 10', 0, 1, 0, 10, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 10' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM10_VC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'V Harmonic C 11', 0, 1, 0, 11, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 11' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM11_VC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'V Harmonic C 12', 0, 1, 0, 12, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 12' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM12_VC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'V Harmonic C 13', 0, 1, 0, 13, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 13' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM13_VC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'V Harmonic C 14', 0, 1, 0, 14, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 14' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM14_VC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'V Harmonic C 15', 0, 1, 0, 15, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 15' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM15_VC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'V Harmonic C 16', 0, 1, 0, 16, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 16' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM16_VC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'V Harmonic C 17', 0, 1, 0, 17, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 17' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM17_VC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'V Harmonic C 18', 0, 1, 0, 18, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 18' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM18_VC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'V Harmonic C 19', 0, 1, 0, 19, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 19' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM19_VC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'V Harmonic C 20', 0, 1, 0, 20, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 20' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM20_VC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'V Harmonic C 21', 0, 1, 0, 21, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 21' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM21_VC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'V Harmonic C 22', 0, 1, 0, 22, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 22' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM22_VC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'V Harmonic C 23', 0, 1, 0, 23, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 23' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM23_VC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'V Harmonic C 24', 0, 1, 0, 24, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 24' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM24_VC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'V Harmonic C 25', 0, 1, 0, 25, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 25' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM25_VC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'V Harmonic C 26', 0, 1, 0, 26, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 26' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM26_VC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'V Harmonic C 27', 0, 1, 0, 27, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 27' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM27_VC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'V Harmonic C 28', 0, 1, 0, 28, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 28' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM28_VC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'V Harmonic C 29', 0, 1, 0, 29, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 29' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM29_VC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'V Harmonic C 30', 0, 1, 0, 30, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 30' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM30_VC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'V Harmonic C 31', 0, 1, 0, 31, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 31' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM31_VC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'V Harmonic C 32', 0, 1, 0, 32, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 32' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM32_VC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'V Harmonic C 33', 0, 1, 0, 33, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 33' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM33_VC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'I Harmonic A 2', 0, 1, 0, 2, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic A 2' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM2_IA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'I Harmonic A 3', 0, 1, 0, 3, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic A 3' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM3_IA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'I Harmonic A 4', 0, 1, 0, 4, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic A 4' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM4_IA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'I Harmonic A 5', 0, 1, 0, 5, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic A 5' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM5_IA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'I Harmonic A 6', 0, 1, 0, 6, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic A 6' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM6_IA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'I Harmonic A 7', 0, 1, 0, 7, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic A 7' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM7_IA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'I Harmonic A 8', 0, 1, 0, 8, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic A 8' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM8_IA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'I Harmonic A 9', 0, 1, 0, 9, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic A 9' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM9_IA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'I Harmonic A 10', 0, 1, 0, 10, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic A 10' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM10_IA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'I Harmonic A 11', 0, 1, 0, 11, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic A 11' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM11_IA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'I Harmonic A 12', 0, 1, 0, 12, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic A 12' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM12_IA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'I Harmonic A 13', 0, 1, 0, 13, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic A 13' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM13_IA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'I Harmonic A 14', 0, 1, 0, 14, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic A 14' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM14_IA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'I Harmonic A 15', 0, 1, 0, 15, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic A 15' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM15_IA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'I Harmonic A 16', 0, 1, 0, 16, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic A 16' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM16_IA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'I Harmonic A 17', 0, 1, 0, 17, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic A 17' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM17_IA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'I Harmonic A 18', 0, 1, 0, 18, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic A 18' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM18_IA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'I Harmonic A 19', 0, 1, 0, 19, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic A 19' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM19_IA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'I Harmonic A 20', 0, 1, 0, 20, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic A 20' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM20_IA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'I Harmonic A 21', 0, 1, 0, 21, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic A 21' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM21_IA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'I Harmonic A 22', 0, 1, 0, 22, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic A 22' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM22_IA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'I Harmonic A 23', 0, 1, 0, 23, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic A 23' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM23_IA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'I Harmonic A 24', 0, 1, 0, 24, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic A 24' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM24_IA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'I Harmonic A 25', 0, 1, 0, 25, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic A 25' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM25_IA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'I Harmonic A 26', 0, 1, 0, 26, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic A 26' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM26_IA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'I Harmonic A 27', 0, 1, 0, 27, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic A 27' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM27_IA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'I Harmonic A 28', 0, 1, 0, 28, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic A 28' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM28_IA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'I Harmonic A 29', 0, 1, 0, 29, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic A 29' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM29_IA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'I Harmonic A 30', 0, 1, 0, 30, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic A 30' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM30_IA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'I Harmonic A 31', 0, 1, 0, 31, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic A 31' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM31_IA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'I Harmonic A 32', 0, 1, 0, 32, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic A 32' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM32_IA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'I Harmonic A 33', 0, 1, 0, 33, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic A 33' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM33_IA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'I Harmonic B 2', 0, 1, 0, 2, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 2' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM2_IB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'I Harmonic B 3', 0, 1, 0, 3, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 3' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM3_IB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'I Harmonic B 4', 0, 1, 0, 4, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 4' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM4_IB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'I Harmonic B 5', 0, 1, 0, 5, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 5' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM5_IB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'I Harmonic B 6', 0, 1, 0, 6, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 6' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM6_IB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'I Harmonic B 7', 0, 1, 0, 7, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 7' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM7_IB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'I Harmonic B 8', 0, 1, 0, 8, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 8' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM8_IB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'I Harmonic B 9', 0, 1, 0, 9, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 9' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM9_IB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'I Harmonic B 10', 0, 1, 0, 10, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 10' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM10_IB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'I Harmonic B 11', 0, 1, 0, 11, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 11' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM11_IB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'I Harmonic B 12', 0, 1, 0, 12, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 12' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM12_IB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'I Harmonic B 13', 0, 1, 0, 13, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 13' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM13_IB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'I Harmonic B 14', 0, 1, 0, 14, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 14' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM14_IB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'I Harmonic B 15', 0, 1, 0, 15, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 15' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM15_IB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'I Harmonic B 16', 0, 1, 0, 16, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 16' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM16_IB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'I Harmonic B 17', 0, 1, 0, 17, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 17' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM17_IB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'I Harmonic B 18', 0, 1, 0, 18, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 18' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM18_IB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'I Harmonic B 19', 0, 1, 0, 19, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 19' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM19_IB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'I Harmonic B 20', 0, 1, 0, 20, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 20' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM20_IB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'I Harmonic B 21', 0, 1, 0, 21, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 21' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM21_IB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'I Harmonic B 22', 0, 1, 0, 22, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 22' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM22_IB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'I Harmonic B 23', 0, 1, 0, 23, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 23' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM23_IB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'I Harmonic B 24', 0, 1, 0, 24, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 24' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM24_IB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'I Harmonic B 25', 0, 1, 0, 25, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 25' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM25_IB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'I Harmonic B 26', 0, 1, 0, 26, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 26' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM26_IB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'I Harmonic B 27', 0, 1, 0, 27, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 27' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM27_IB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'I Harmonic B 28', 0, 1, 0, 28, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 28' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM28_IB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'I Harmonic B 29', 0, 1, 0, 29, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 29' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM29_IB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'I Harmonic B 30', 0, 1, 0, 30, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 30' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM30_IB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'I Harmonic B 31', 0, 1, 0, 31, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 31' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM31_IB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'I Harmonic B 32', 0, 1, 0, 32, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 32' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM32_IB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'I Harmonic B 33', 0, 1, 0, 33, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 33' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM33_IB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'I Harmonic C 2', 0, 1, 0, 2, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 2' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM2_IC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'I Harmonic C 3', 0, 1, 0, 3, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 3' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM3_IC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'I Harmonic C 4', 0, 1, 0, 4, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 4' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM4_IC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'I Harmonic C 5', 0, 1, 0, 5, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 5' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM5_IC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'I Harmonic C 6', 0, 1, 0, 6, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 6' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM6_IC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'I Harmonic C 7', 0, 1, 0, 7, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 7' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM7_IC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'I Harmonic C 8', 0, 1, 0, 8, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 8' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM8_IC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'I Harmonic C 9', 0, 1, 0, 9, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 9' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM9_IC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'I Harmonic C 10', 0, 1, 0, 10, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 10' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM10_IC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'I Harmonic C 11', 0, 1, 0, 11, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 11' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM11_IC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'I Harmonic C 12', 0, 1, 0, 12, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 12' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM12_IC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'I Harmonic C 13', 0, 1, 0, 13, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 13' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM13_IC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'I Harmonic C 14', 0, 1, 0, 14, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 14' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM14_IC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'I Harmonic C 15', 0, 1, 0, 15, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 15' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM15_IC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'I Harmonic C 16', 0, 1, 0, 16, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 16' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM16_IC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'I Harmonic C 17', 0, 1, 0, 17, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 17' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM17_IC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'I Harmonic C 18', 0, 1, 0, 18, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 18' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM18_IC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'I Harmonic C 19', 0, 1, 0, 19, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 19' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM19_IC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'I Harmonic C 20', 0, 1, 0, 20, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 20' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM20_IC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'I Harmonic C 21', 0, 1, 0, 21, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 21' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM21_IC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'I Harmonic C 22', 0, 1, 0, 22, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 22' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM22_IC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'I Harmonic C 23', 0, 1, 0, 23, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 23' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM23_IC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'I Harmonic C 24', 0, 1, 0, 24, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 24' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM24_IC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'I Harmonic C 25', 0, 1, 0, 25, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 25' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM25_IC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'I Harmonic C 26', 0, 1, 0, 26, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 26' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM26_IC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'I Harmonic C 27', 0, 1, 0, 27, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 27' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM27_IC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'I Harmonic C 28', 0, 1, 0, 28, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 28' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM28_IC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'I Harmonic C 29', 0, 1, 0, 29, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 29' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM29_IC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'I Harmonic C 30', 0, 1, 0, 30, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 30' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM30_IC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'I Harmonic C 31', 0, 1, 0, 31, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 31' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM31_IC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'I Harmonic C 32', 0, 1, 0, 32, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 32' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM32_IC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name LIKE 'Hummel'),
(SELECT ID FROM Asset WHERE AssetName LIKE 'Hummel'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'I Harmonic C 33', 0, 1, 0, 33, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 33' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE 'Hummel')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM33_IC_10MIN');